{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Template","Home","Jan 2015","Reference","Selection"],"not_rendered":{"charts":3,"images":11,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Budget Sheet/Spending Tracker"]
[]
[null,null,null,"Beginning:","2014-12-02"]
[null,null,null,"Ending: ","2014-12-14"]
[]
["Date","W/D","Description","Amount","Category",null,null,null,null,"Auto:",{"$f":"SUMIF($E$7:E100,\"Auto\",$D$7:D100)","v":200.37000000000003}]
["2014-12-01","W","Gas - Chevron",46.32,"Auto",null,null,null,null,"Bill: ",{"$f":"SUMIF($E$7:E101,\"Bill\",$D$7:D101)","v":1649.12}]
["2014-12-01","W","Winco - Groceries",23.15,"Grocery",null,null,null,null,"Clothes:",{"$f":"SUMIF($E$7:E102,\"Clothes\",$D$7:D102)","v":59.35}]
["2014-12-02","W","Car Insurance",231.8,"Bill",null,"Total Transactions: ",{"$f":"COUNT(D7:D499)","v":41},null,"Education:",{"$f":"SUMIF($E$7:E103,\"Education\",$D$7:D103)","v":5.63}]
["2014-12-02","W","Walmart - Gift",25.38,"Other",null,"Total Expenditures: ",{"$f":"SUMIF($B$7:B100,\"W\",$D$7:D97)","v":2546.5299999999997},null,"Entertainment:",{"$f":"SUMIF($E$7:E104,\"Entertainment\",$D$7:D104)","v":43.040000000000006}]
["2014-12-04","W","Phone Bill",78.53,"Bill",null,"Total Income: ",{"$f":"SUMIF($E$7:E150,\"Paycheck\",$D$7:D98)","v":2569.4399999999996},null,"Food:",{"$f":"SUMIF($E$7:E105,\"Food\",$D$7:D105)","v":98.009999999999991}]
["2014-12-04","W","McDonalds",8.27,"Food",null,null,null,null,"Grocery:",{"$f":"SUMIF($E$7:E106,\"Grocery\", $D$7:D106)","v":253.8}]
["2014-12-04","D","Walmart - Refund",13.64,"Deposit",null,null,null,null,"Home Improvement:",{"$f":"SUMIF($E$7:E107,\"Home Improvement\",$D$7:D107)","v":43.18}]
["2014-12-05","W","Home Depot",43.18,"Home Improvement",null,null,null,null,"Other:",{"$f":"SUMIF($E$7:E108,\"Other\",$D$7:D108)","v":25.38}]
["2014-12-06","W","JCPennys",17.690000000000001,"Clothes",null,null,null,null,"Tithing: ",{"$f":"SUMIF($E$7:E109,\"Tithing\",$D$7:D109)","v":122.98}]
["2014-12-06","W","Sears",5.37,"Clothes"]
["2014-12-06","W","Ross",36.29,"Clothes"]
["2014-12-07","W","Carrabbas",47,"Food"]
["2014-12-08","D","Paycheck",376.14,"Paycheck"]
["2014-12-10","D","Paycheck",853.65,"Paycheck"]
["2014-12-10","W","Rent",750,"Bill"]
["2014-12-11","W","Maceys",18.16,"Grocery"]
["2014-12-13","W","Tithing",122.98,"Tithing"]
["2014-12-13","W","Hulu",7.99,"Bill"]
["2014-12-13","W","Dollar Tree",5.63,"Education"]
["2014-12-14","W","Student Loans",89.65,"Bill"]
["2014-12-14","W","Gas - Chevron",37.89,"Auto"]
["2014-12-14","W","Car Payment",275.13,"Bill"]
["2014-12-14","W","Winco - Groceries",67.430000000000007,"Grocery"]
["2014-12-14","W","Redbox",1.67,"Entertainment"]
["2014-12-15","W","Dairy Queen",6.74,"Food"]
["2014-12-16","W","Gas - Chevron",42.18,"Auto"]
["2014-12-18","W","Costco - Groceries",45.42,"Grocery"]
["2014-12-18","W","State Farm - Life Insurance",22.67,"Bill"]
["2014-12-18","W","Oreilly Auto - Wipers",21.74,"Auto"]
["2014-12-19","W","Carrabbas",36,"Food"]
["2014-12-21","W","Ice Skating",15,"Entertainment"]
["2014-12-22","D","Paycheck",402.87,"Paycheck"]
["2014-12-22","W","Rite Aid - Medicine",7.48,"Grocery"]
["2014-12-22","W","Car Payment",193.35,"Bill"]
["2014-12-24","D","Paycheck",936.78,"Paycheck"]
["2014-12-26","W","Gas - Maverick",52.24,"Auto"]
["2014-12-28","D","Christmas Cash",250,"Deposit"]
["2014-12-28","W","Winco - Groceries",72.930000000000007,"Grocery"]
["2014-12-29","W","Walmart - Party Supplies",26.37,"Entertainment"]
["2014-12-29","W","Maceys",19.23,"Grocery"]
["2014-12-30","W","Gas - Chevron",45.67,"Auto "]

{"sheet":"Home","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Jan 2015","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Budget Sheet/Spending Tracker"]
[]
[null,null,null,"Beginning:","2015-01-01"]
[null,null,null,"Ending: ","2015-01-31"]
[]
["Date","W/D","Description","Amount","Category",null,null,null,null,"Auto:",{"$f":"SUMIF($E$7:E100,\"Auto\",$D$7:D100)","v":0}]
[null,null,null,null,null,null,null,null,null,"Bill: ",{"$f":"SUMIF($E$7:E101,\"Bill\",$D$7:D101)","v":0}]
[null,null,null,null,null,null,null,null,null,"Clothes:",{"$f":"SUMIF($E$7:E102,\"Clothes\",$D$7:D102)","v":0}]
[null,null,null,null,null,null,"Total Transactions: ",{"$f":"COUNT(D7:D499)","v":0},null,"Education:",{"$f":"SUMIF($E$7:E103,\"Education\",$D$7:D103)","v":0}]
[null,null,null,null,null,null,"Total Expenditures: ",{"$f":"SUMIF($B$7:B100,\"W\",$D$7:D97)","v":0},null,"Entertainment:",{"$f":"SUMIF($E$7:E104,\"Entertainment\",$D$7:D104)","v":0}]
[null,null,null,null,null,null,"Total Income: ",{"$f":"SUMIF($E$7:E150,\"Paycheck\",$D$7:D98)","v":0},null,"Food:",{"$f":"SUMIF($E$7:E105,\"Food\",$D$7:D105)","v":0}]
[null,null,null,null,null,null,null,null,null,"Grocery:",{"$f":"SUMIF($E$7:E106,\"Grocery\", $D$7:D106)","v":0}]
[null,null,null,null,null,null,null,null,null,"Home Improvement:",{"$f":"SUMIF($E$7:E107,\"Home Improvement\",$D$7:D107)","v":0}]
[null,null,null,null,null,null,null,null,null,"Other:",{"$f":"SUMIF($E$7:E108,\"Other\",$D$7:D108)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tithing: ",{"$f":"SUMIF($E$7:E109,\"Tithing\",$D$7:D109)","v":0}]

{"sheet":"Reference","index":3,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[[4,8,4,10]]}
["Date","W/D","Item","Amount","Category"]
["2014-12-01","W","Gas - Chevron",46.32,"Auto"]
["2014-12-01","W","Winco - Groceries",23.15,"Grocery"]
["2014-12-02","W","Car Insurance",231.8,"Bill"]
["2014-12-02","W","Walmart - Gift",25.38,"Special",null,"Categories",null,"Date:"]
["2014-12-04","W","Phone Bill",78.53,"Bill",null,"Auto",null,"Jan ",1,2014]
["2014-12-04","W","McDonalds",8.27,"Food",null,"Bill",null,"Feb ",2,2015]
["2014-12-04","D","Walmart - Refund",13.64,"Deposit",null,"Clothes",null,"Mar ",3,2016]
["2014-12-05","W","Home Depot",43.18,"Home Improvement",null,"Deposit",null,"Apr ",4,2017]
["2014-12-06","W","JCPennys",17.690000000000001,"Clothes",null,"Education",null,"May ",5,2018]
["2014-12-06","W","Sears",5.37,"Clothes",null,"Entertainment",null,"Jun ",6,2019]
["2014-12-06","W","Ross",36.29,"Clothes",null,"Food",null,"Jul ",7,2020]
["2014-12-07","W","Carrabbas",47,"Food",null,"Grocery",null,"Aug ",8]
["2014-12-08","D","Paycheck",376.14,"Paycheck",null,"Home Improvement",null,"Sep ",9]
["2014-12-10","D","Paycheck",853.65,"Paycheck",null,"Other",null,"Oct ",10]
["2014-12-10","W","Rent",750,"Bill",null,"Paycheck",null,"Nov ",11]
["2014-12-11","W","Maceys",18.16,"Grocery",null,"Tithing",null,"Dec ",12]
["2014-12-13","W","Tithing",122.98,"Tithing",null,null,null,null,13]
["2014-12-13","W","Hulu",7.99,"Bill",null,null,null,null,14]
["2014-12-13","W","Dollar Tree",5.63,"Education",null,null,null,null,15]
["2014-12-14","W","Student Loans",89.65,"Bill",null,null,null,null,16]
["2014-12-14","W","Gas - Chevron",37.89,"Auto",null,null,null,null,17]
["2014-12-14","W","Car Payment",275.13,"Bill",null,null,null,null,18]
["2014-12-14","W","Winco - Groceries",67.430000000000007,"Grocery",null,null,null,null,19]
["2014-12-14","W","Redbox",1.67,"Entertainment",null,null,null,null,20]
["2014-12-15","W","Dairy Queen",6.74,"Food",null,null,null,null,21]
["2014-12-16","W","Gas - Chevron",42.18,"Auto",null,null,null,null,22]
["2014-12-18","W","Costco - Groceries",45.42,"Grocery",null,null,null,null,23]
["2014-12-18","W","State Farm - Life Insurance",22.67,"Bill",null,null,null,null,24]
["2014-12-18","W","Oreilly Auto - Wipers",21.74,"Auto",null,null,null,null,25]
["2014-12-19","W","Carrabbas",36,"Food",null,null,null,null,26]
["2014-12-21","W","Ice Skating",15,"Entertainment",null,null,null,null,27]
["2014-12-22","D","Paycheck",402.87,"Paycheck",null,null,null,null,28]
["2014-12-22","W","Rite Aid - Medicine",7.48,"Grocery",null,null,null,null,29]
["2014-12-22","W","Car Payment",193.35,"Bill",null,null,null,null,30]
["2014-12-24","D","Paycheck",936.78,"Paycheck",null,null,null,null,31]
["2014-12-26","W","Gas - Maverick",52.24,"Auto"]
["2014-12-28","D","Christmas Cash",250,"Deposit"]
["2014-12-28","W","Winco - Groceries",72.930000000000007,"Grocery"]
["2014-12-29","W","Walmart - Party Supplies",26.37,"Entertainment"]
["2014-12-29","W","Maceys",19.23,"Grocery"]
["2014-12-30","W","Gas - Chevron",45.67,"Auto"]

{"sheet":"Selection","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Date","W/D","Description","Amount","Category"]
[null,null,null,null,null,null,"Total Transactions: ",{"$f":"COUNT(D2:D495)","v":0}]
[null,null,null,null,null,null,"Total Expenditures: ",{"$f":"SUMIF($B$2:B96,\"W\",$D$2:D93)","v":0}]
[null,null,null,null,null,null,"Total Income: ",{"$f":"SUMIF($E$2:E97,\"Paycheck\",$D$2:D94)","v":0}]
[]
[]
[null,null,null,null,null,null,"Auto:",{"$f":"SUMIF($E$2:E91,\"Auto\",$D$2:D91)","v":0}]
[null,null,null,null,null,null,"Bills: ",{"$f":"SUMIF($E$2:E92,\"Bill\",$D$2:D92)","v":0}]
[null,null,null,null,null,null,"Clothes:",{"$f":"SUMIF($E$2:E93,\"Clothes\",$D$2:D93)","v":0}]
[null,null,null,null,null,null,"Education:",{"$f":"SUMIF($E$2:E94,\"Education\",$D$2:D94)","v":0}]
[null,null,null,null,null,null,"Entertainment:",{"$f":"SUMIF($E$2:E95,\"Entertainment\",$D$2:D95)","v":0}]
[null,null,null,null,null,null,"Food:",{"$f":"SUMIF($E$2:E96,\"Food\",$D$2:D96)","v":0}]
[null,null,null,null,null,null,"Grocery:",{"$f":"SUMIF($E$2:E97,\"Grocery\", $D$2:D97)","v":0}]
[null,null,null,null,null,null,"Home Improvement:",{"$f":"SUMIF($E$2:E98,\"Home Improvement\",$D$2:D98)","v":0}]
[null,null,null,null,null,null,"Other:",{"$f":"SUMIF($E$2:E99,\"Other\",$D$2:D99)","v":0}]
[null,null,null,null,null,null,"Tithing: ",{"$f":"SUMIF($E$2:E100,\"Tithing\",$D$2:D100)","v":0}]